Convert Squarespace Profiles to Shopify Customers in Google Sheets
工作流概述
这是一个包含8个节点的中等工作流，主要用于自动化处理各种任务。
工作流源代码
{
"id": "7Gw4IfHaVMDSj70o",
"meta": {
"instanceId": "e634e668fe1fc93a75c4f2a7fc0dad807ca318b79654157eadb9578496acbc76",
"templateCredsSetupCompleted": true
},
"name": "Convert Squarespace Profiles to Shopify Customers in Google Sheets",
"tags": [],
"nodes": [
{
"id": "17b7e952-ba9b-4067-9c98-a69ea09f7e69",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
-800,
-420
],
"webhookId": "e09976b5-7525-422b-9834-3bc6e1c4a1b6",
"parameters": {
"path": "submit-profiles",
"options": {
"allowedOrigins": "*"
},
"httpMethod": "POST"
},
"typeVersion": 2
},
{
"id": "7e149be3-19da-4320-8910-40ef0900628a",
"name": "Shopify Customers",
"type": "n8n-nodes-base.googleSheets",
"position": [
420,
-220
],
"parameters": {
"columns": {
"value": {
"Tags": "=n8n, squarespace, {{ $json['Last Order Date'] ? \"ground-control,\" : \"\" }}",
"Email": "={{ $json.Email }}",
"Phone": "={{ $json['Billing Phone Number'] }}",
"Last Name": "={{ $json['Last Name'] }}",
"First Name": "={{ $json['First Name'] }}",
"Default Address Zip": "={{ $json['Billing Zip'] }}",
"Default Address City": "={{ $json['Billing City'] }}",
"Default Address Phone": "={{ $json['Billing Phone Number'] }}",
"Accepts Email Marketing": "yes",
"Default Address Company": "={{ $json['Billing Name'] }}",
"Default Address Address1": "={{ $json['Billing Address 1'] }}",
"Default Address Address2": "={{ $json['Billing Address 2'] }}",
"Default Address Country Code": "={{ $json['Billing Country'] }}",
"Default Address Province Code": "={{ $json['Billing Province/State'] }}"
},
"schema": [
{
"id": "First Name",
"type": "string",
"display": true,
"required": false,
"displayName": "First Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Last Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Accepts Email Marketing",
"type": "string",
"display": true,
"required": false,
"displayName": "Accepts Email Marketing",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Default Address Company",
"type": "string",
"display": true,
"required": false,
"displayName": "Default Address Company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Default Address Address1",
"type": "string",
"display": true,
"required": false,
"displayName": "Default Address Address1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Default Address Address2",
"type": "string",
"display": true,
"required": false,
"displayName": "Default Address Address2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Default Address City",
"type": "string",
"display": true,
"required": false,
"displayName": "Default Address City",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Default Address Province Code",
"type": "string",
"display": true,
"required": false,
"displayName": "Default Address Province Code",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Default Address Country Code",
"type": "string",
"display": true,
"required": false,
"displayName": "Default Address Country Code",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Default Address Zip",
"type": "string",
"display": true,
"required": false,
"displayName": "Default Address Zip",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Default Address Phone",
"type": "string",
"display": true,
"required": false,
"displayName": "Default Address Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone",
"type": "string",
"display": true,
"required": false,
"displayName": "Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Accepts SMS Marketing",
"type": "string",
"display": true,
"required": false,
"displayName": "Accepts SMS Marketing",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Tags",
"type": "string",
"display": true,
"required": false,
"displayName": "Tags",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Note",
"type": "string",
"display": true,
"required": false,
"displayName": "Note",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Tax Exempt",
"type": "string",
"display": true,
"required": false,
"displayName": "Tax Exempt",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 15798644,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yf_RYZGFHpMyOvD3RKGSvIFY2vumvI4474Qm_1t4-jM/edit#gid=15798644",
"cachedResultName": "shopify_template"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1yf_RYZGFHpMyOvD3RKGSvIFY2vumvI4474Qm_1t4-jM",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yf_RYZGFHpMyOvD3RKGSvIFY2vumvI4474Qm_1t4-jM/edit?usp=drivesdk",
"cachedResultName": "Make.com template"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "JgI9maibw5DnBXRP",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "e04f9a9e-b699-4cf2-aa91-56e6bfa30faa",
"name": "Read Squarespace profiles",
"type": "n8n-nodes-base.googleSheets",
"position": [
-180,
0
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 144532755,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yf_RYZGFHpMyOvD3RKGSvIFY2vumvI4474Qm_1t4-jM/edit#gid=144532755",
"cachedResultName": "squarespace_profiles"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1yf_RYZGFHpMyOvD3RKGSvIFY2vumvI4474Qm_1t4-jM",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yf_RYZGFHpMyOvD3RKGSvIFY2vumvI4474Qm_1t4-jM/edit?usp=drivesdk",
"cachedResultName": "Squarespace automation"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "JgI9maibw5DnBXRP",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "ffebc458-bd3c-4145-a5ef-1677815f210e",
"name": "Append Squarespace profiles",
"type": "n8n-nodes-base.googleSheets",
"position": [
-200,
-420
],
"parameters": {
"columns": {
"value": {
"Email": "={{ $json.Email }}",
"Last Name": "={{ $json['Last Name'] }}",
"Created On": "={{ $json['Created On'] }}",
"First Name": "={{ $json['First Name'] }}",
"Billing Zip": "={{ $json['Billing Zip'] }}",
"Order Count": "={{ $json['Order Count'] }}",
"Total Spent": "={{ $json['Total Spent'] }}",
"Billing City": "={{ $json['Billing City'] }}",
"Billing Name": "={{ $json['Billing Name'] }}",
"Shipping Zip": "={{ $json['Billing Zip'] }}",
"Shipping City": "={{ $json['Billing City'] }}",
"Shipping Name": "={{ $json['Billing Name'] }}",
"Billing Country": "={{ $json['Billing Country'] }}",
"Last Order Date": "={{ $json['Last Order Date'] }}",
"Shipping Country": "={{ $json['Billing Country'] }}",
"Subscriber Since": "={{ $json['Subscriber Since'] }}",
"Billing Address 1": "={{ $json['Billing Address 1'] }}",
"Billing Address 2": "={{ $json['Billing Address 2'] }}",
"Subscriber Source": "={{ $json['Subscriber Source'] }}",
"Shipping Address 1": "={{ $json['Billing Address 1'] }}",
"Shipping Address 2": "={{ $json['Billing Address 2'] }}",
"Billing Phone Number": "={{ $json['Billing Phone Number'] }}",
"Shipping Phone Number": "={{ $json['Billing Phone Number'] }}",
"Billing Province/State": "={{ $json['Billing Province/State'] }}",
"Shipping Province/State": "={{ $json['Billing Province/State'] }}"
},
"schema": [
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "First Name",
"type": "string",
"display": true,
"required": false,
"displayName": "First Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Last Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Created On",
"type": "string",
"display": true,
"required": false,
"displayName": "Created On",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Order Count",
"type": "string",
"display": true,
"required": false,
"displayName": "Order Count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Order Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Last Order Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Total Spent",
"type": "string",
"display": true,
"required": false,
"displayName": "Total Spent",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Member Since",
"type": "string",
"display": true,
"required": false,
"displayName": "Member Since",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Subscriber Since",
"type": "string",
"display": true,
"required": false,
"displayName": "Subscriber Since",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Subscriber Source",
"type": "string",
"display": true,
"required": false,
"displayName": "Subscriber Source",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Tags",
"type": "string",
"display": true,
"required": false,
"displayName": "Tags",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Mailing Lists",
"type": "string",
"display": true,
"required": false,
"displayName": "Mailing Lists",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Member Areas",
"type": "string",
"display": true,
"required": false,
"displayName": "Member Areas",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Donation Count",
"type": "string",
"display": true,
"required": false,
"displayName": "Donation Count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Donation Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Last Donation Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Total Donation Amount",
"type": "string",
"display": true,
"required": false,
"displayName": "Total Donation Amount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Has Account",
"type": "string",
"display": true,
"required": false,
"displayName": "Has Account",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Customer Since",
"type": "string",
"display": true,
"required": false,
"displayName": "Customer Since",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Shipping Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Shipping Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Shipping Address 1",
"type": "string",
"display": true,
"required": false,
"displayName": "Shipping Address 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Shipping Address 2",
"type": "string",
"display": true,
"required": false,
"displayName": "Shipping Address 2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Shipping City",
"type": "string",
"display": true,
"required": false,
"displayName": "Shipping City",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Shipping Zip",
"type": "string",
"display": true,
"required": false,
"displayName": "Shipping Zip",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Shipping Province/State",
"type": "string",
"display": true,
"required": false,
"displayName": "Shipping Province/State",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Shipping Country",
"type": "string",
"display": true,
"required": false,
"displayName": "Shipping Country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Shipping Phone Number",
"type": "string",
"display": true,
"required": false,
"displayName": "Shipping Phone Number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Billing Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Billing Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Billing Address 1",
"type": "string",
"display": true,
"required": false,
"displayName": "Billing Address 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Billing Address 2",
"type": "string",
"display": true,
"required": false,
"displayName": "Billing Address 2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Billing City",
"type": "string",
"display": true,
"required": false,
"displayName": "Billing City",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Billing Zip",
"type": "string",
"display": true,
"required": false,
"displayName": "Billing Zip",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Billing Province/State",
"type": "string",
"display": true,
"required": false,
"displayName": "Billing Province/State",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Billing Country",
"type": "string",
"display": true,
"required": false,
"displayName": "Billing Country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Billing Phone Number",
"type": "string",
"display": true,
"required": false,
"displayName": "Billing Phone Number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Accepts Marketing",
"type": "string",
"display": true,
"required": false,
"displayName": "Accepts Marketing",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 144532755,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yf_RYZGFHpMyOvD3RKGSvIFY2vumvI4474Qm_1t4-jM/edit#gid=144532755",
"cachedResultName": "squarespace_profiles"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1yf_RYZGFHpMyOvD3RKGSvIFY2vumvI4474Qm_1t4-jM",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yf_RYZGFHpMyOvD3RKGSvIFY2vumvI4474Qm_1t4-jM/edit?usp=drivesdk",
"cachedResultName": "Squarespace automation"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "JgI9maibw5DnBXRP",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5,
"alwaysOutputData": true
},
{
"id": "dc5cfb81-0d9b-47fb-a97a-fa20c673283b",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-360,
-420
],
"parameters": {
"options": {},
"batchSize": 1000
},
"typeVersion": 3
},
{
"id": "b319cb05-6b8b-48cb-b7c9-4badee6bbf57",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1240,
-580
],
"parameters": {
"width": 340,
"height": 280,
"content": "## Convert Squarespace profiles
Convert exported profile from Squarespace to compatible Shopify customers data in csv format
Sample Spreadsheet template
https://docs.google.com/spreadsheets/d/1ZUP7RySMCjQUBAvlZhSE1rOul1FMVHvTSF0QexuV7mQ
- Squarespace profiles
- Shopify customers"
},
"typeVersion": 1
},
{
"id": "8b9d6f85-af6e-43b8-a3f1-c63c7893e064",
"name": "Extract items from webhook submission",
"type": "n8n-nodes-base.extractFromFile",
"position": [
-580,
-420
],
"parameters": {
"options": {},
"binaryPropertyName": "file"
},
"typeVersion": 1
},
{
"id": "ce82f958-081b-4a55-a0d1-8ffb69dee68b",
"name": "Manual trigger",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-580,
0
],
"parameters": {},
"typeVersion": 1
}
],
"active": true,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "05db75a8-16f8-4191-b60b-d515d062bef9",
"connections": {
"Webhook": {
"main": [
[
{
"node": "Extract items from webhook submission",
"type": "main",
"index": 0
}
]
]
},
"Manual trigger": {
"main": [
[
{
"node": "Read Squarespace profiles",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[
{
"node": "Shopify Customers",
"type": "main",
"index": 0
}
],
[
{
"node": "Append Squarespace profiles",
"type": "main",
"index": 0
}
]
]
},
"Read Squarespace profiles": {
"main": [
[
{
"node": "Shopify Customers",
"type": "main",
"index": 0
}
]
]
},
"Append Squarespace profiles": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Extract items from webhook submission": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
}
}
}功能特点
- 自动检测新邮件
- AI智能内容分析
- 自定义分类规则
- 批量处理能力
- 详细的处理日志
技术分析
节点类型及作用
- Webhook
- Googlesheets
- Splitinbatches
- Stickynote
- Extractfromfile
复杂度评估
配置难度：
维护难度：
扩展性：
实施指南
前置条件
- 有效的Gmail账户
- n8n平台访问权限
- Google API凭证
- AI分类服务订阅
配置步骤
- 在n8n中导入工作流JSON文件
- 配置Gmail节点的认证信息
- 设置AI分类器的API密钥
- 自定义分类规则和标签映射
- 测试工作流执行
- 配置定时触发器（可选）
关键参数
| 参数名称 | 默认值 | 说明 |
|---|---|---|
| maxEmails | 50 | 单次处理的最大邮件数量 |
| confidenceThreshold | 0.8 | 分类置信度阈值 |
| autoLabel | true | 是否自动添加标签 |
最佳实践
优化建议
- 定期更新AI分类模型以提高准确性
- 根据邮件量调整处理批次大小
- 设置合理的分类置信度阈值
- 定期清理过期的分类规则
安全注意事项
- 妥善保管API密钥和认证信息
- 限制工作流的访问权限
- 定期审查处理日志
- 启用双因素认证保护Gmail账户
性能优化
- 使用增量处理减少重复工作
- 缓存频繁访问的数据
- 并行处理多个邮件分类任务
- 监控系统资源使用情况
故障排除
常见问题
邮件未被正确分类
检查AI分类器的置信度阈值设置，适当降低阈值或更新训练数据。
Gmail认证失败
确认Google API凭证有效且具有正确的权限范围，重新进行OAuth授权。
调试技巧
- 启用详细日志记录查看每个步骤的执行情况
- 使用测试邮件验证分类逻辑
- 检查网络连接和API服务状态
- 逐步执行工作流定位问题节点
错误处理
工作流包含以下错误处理机制：
- 网络超时自动重试（最多3次）
- API错误记录和告警
- 处理失败邮件的隔离机制
- 异常情况下的回滚操作